Displaying 1-20 of 1254 results
Exclusive
Simple but effective, part 5
- 24 Jun 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. As part of our journey through the capabilities of Tables, this time we are going to examine some of the options available in the contextual Table Design Ribbon tab.
Exclusive
Top 12 Excel Combinations: 7. OFFSET MATCH
- 24 Jun 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers OFFSET MATCH.
Exclusive
General Election 2024
- 24 Jun 2024
- Simon Hurst
General Election 2024 – why the numbers are wrong
NEW TECH FEATURES
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Mar-May 2024
- 14 Jun 2024
- David Benaim
David Benaim presents a digest of new features across Microsoft 365 and other business tech products in written, images and video format, covering the last three months.
The easy way to implement Excel principles
- 13 Jun 2024
- PerfectXL
What unites accountants? Excel, of course! I’m sure you'll agree that Excel's integral role in accountancy demands that spreadsheets meet certain standards, but that is easier said than done. In this article, PerfectXL explore what exactly you should be mindful of when working in Excel.
Exclusive
Article archive access
- 06 Jun 2024
- Simon Hurst
Article archive access – have we already solved your Excel issue?
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #491 – Creating a dynamic lead schedule
- 29 May 2024
- James Berridge
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring how to use VSTACK, CHOOSECOLS and FILTER to create a dynamic lead schedule and dynamic dropdown options.
Exclusive
Simple but effective, part 4
- 28 May 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. This time we focus on the use of Data Validation and Dynamic Arrays to automate the creation of summary reports.
Exclusive
Avoid Column Name errors in Power Query
- 24 May 2024
- Mark Proctor
Changing column names are a frequent cause of Power Query errors. This article explores a few techniques to avoid those errors and ensure Power Query refresh runs smoothly.
Exclusive
Top 12 Excel Combinations: 8. INDEX SEQUENCE
- 22 May 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers INDEX SEQUENCE
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #490 – Revisiting data entry shortcuts
- 21 May 2024
- Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post revisiting simple keyboard shortcuts that helps expedite entry of data into Excel.
Exclusive
Simple but effective, part 3 - extending Tables
- 09 May 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. So far, we have considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. We have also seen how new rows and columns are automatically incorporated into existing Tables. This time, we will start by changing the dimensions of Tables manually.
Exclusive
Top 12 Excel Combinations: 9. NOT ISNUMBER
- 08 May 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers NOT ISNUMBER.
EXCEL COMMUNITY ROUND UP
Excel Community round up – April 2024
- 01 May 2024
- Excel Community
Here are all the new Excel blogs from the Excel Community in April 2024.
Exclusive
Finding the missing link – Edit links enhanced
- 25 Apr 2024
- Simon Hurst
Links to cells in other workbooks are a frequent cause of confusion. It can be particularly difficult to track down some of the more elusive ways in which one spreadsheet can be linked to another. A Find Next command available as part of an enhancement to the previous Edit Links command might now be able to help.
Exclusive
IRR, XIRR & MIRR – What are they? When to use them?
- 23 Apr 2024
- Mark Proctor
IRR is commonly used to help make project investment decisions. In this article, Mark Proctor returns to explore the use of the IRR function in Excel and potential alternatives.
Exclusive
Simple but effective, part 2
- 18 Apr 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. In part 1 we considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #489 – The basics of charts in Excel part 2: Combo charts
- 08 Apr 2024
- Tom Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the concept of a combo chart in Excel that can be used for two or more series of data.
Exclusive
Top 12 Excel Combinations: 10. SUMPRODUCT SIGN (Multiple Conditions with OR)
- 03 Apr 2024
- Liam Bastick
I the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers . SUMPRODUCT SIGN (Multiple Conditions with OR).
Exclusive
Excelators Ready!
- 01 Apr 2024
- Simon Hurst
In breaking news, there are rumours that a major Excel update might be on the way that could allow you to create and use your own Excel nickname within Excel’s personalisation options. If this is true, you’d be a fool not to give it a try.
Displaying 1-20 of 1254 results
Excel Community archive
This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search.